Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ERRORTEXT

The ERRORTEXT option holds the text of the first error message that occurs when you execute a program or a statement.

Note: The name of the error whose message is found in ERRORTEXT is contained in the option ERRORNAME. See the entries for ERRORNAME and TRAP for more information about handling Oracle OLAP errors. The ERRNAMES option controls whether the value of the ERRORTEXT option contains the name of the error (that is, the value of the ERRORNAME option) as well as the text of the error message.

Data type

TEXT

Syntax

ERRORTEXT

Examples

Example 11-31 ERRORTEXT with the SIGNAL Command

In a report program that uses a TRAP command to handle errors, you can use the SIGNAL command to send the appropriate error message to the current outfile.

    DEFINE myreport PROGRAM
    LD Monthly Report
    PROGRAM
    TRAP ON CLEANUP NOPRINT
    PUSH month DECIMALS LSIZE PAGESIZE
    LIMIT month TO LAST 1
       ...
    POP month DECIMALS LSIZE PAGESIZE
    RETURN
    CLEANUP:
    POP month DECIMALS LSIZE PAGESIZE
    SIGNAL ERRORNAME ERRORTEXT
    END